CREATE TABLE [dbo].[Report_Desc]
(
[ImisSystem] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_ImisSystem] DEFAULT (''),
[Category] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_Category] DEFAULT (''),
[Title] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_Title] DEFAULT (''),
[Description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Hide] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_Hide] DEFAULT ((0)),
[RequiredLicense] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_RequiredLicense] DEFAULT (''),
[Format] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_Format] DEFAULT (''),
[DialogWindow] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_DialogWindow] DEFAULT (''),
[RunProcedure] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_RunProcedure] DEFAULT (''),
[ProportionalSpaced] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_ProportionalSpaced] DEFAULT ((0)),
[Landscape] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_Landscape] DEFAULT ((0)),
[PrintSetup] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_PrintSetup] DEFAULT ((0)),
[LinesPerPage] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Report_Desc_LinesPerPage] DEFAULT ((0)),
[CharactersPerLine] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Report_Desc_CharactersPerLine] DEFAULT ((0)),
[TopMargin] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Report_Desc_TopMargin] DEFAULT ((0)),
[BottomMargin] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Report_Desc_BottomMargin] DEFAULT ((0)),
[LeftMargin] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Report_Desc_LeftMargin] DEFAULT ((0)),
[LabelWidth] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Report_Desc_LabelWidth] DEFAULT ((0)),
[LabelsAcross] [int] NOT NULL CONSTRAINT [DF_Report_Desc_LabelsAcross] DEFAULT ((0)),
[RecordSpace] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Report_Desc_RecordSpace] DEFAULT ((0)),
[RepeatFactor] [int] NOT NULL CONSTRAINT [DF_Report_Desc_RepeatFactor] DEFAULT ((0)),
[ExportType] [tinyint] NOT NULL CONSTRAINT [DF_Report_Desc_ExportType] DEFAULT ((0)),
[OutputFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_OutputFile] DEFAULT (''),
[ReportOptions] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Parameters] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TableNames] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_TableNames] DEFAULT (''),
[SearchTables] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_SearchTables] DEFAULT (''),
[SelectNames] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SearchExpression] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ColumnHeadings] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_ColumnHeadings] DEFAULT (''),
[LetterText] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LetterType] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_LetterType] DEFAULT (''),
[MenuFields] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_MenuFields] DEFAULT (''),
[Sort1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_Sort1] DEFAULT (''),
[Sort2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_Sort2] DEFAULT (''),
[Sort3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_Sort3] DEFAULT (''),
[Sort4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_Sort4] DEFAULT (''),
[AllowParameterEdit] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_AllowParameterEdit] DEFAULT ((0)),
[AllowMarginEdit] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_AllowMarginEdit] DEFAULT ((0)),
[AllowSearchEdit] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_AllowSearchEdit] DEFAULT ((0)),
[AllowSortEdit] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_AllowSortEdit] DEFAULT ((0)),
[AllowExportEdit] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_AllowExportEdit] DEFAULT ((0)),
[StandardReport] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_StandardReport] DEFAULT ((0)),
[AllowUserFieldEdit] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_AllowUserFieldEdit] DEFAULT ((0)),
[UF1] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF1] DEFAULT (''),
[UF2] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF2] DEFAULT (''),
[UF3] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF3] DEFAULT (''),
[UF4] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF4] DEFAULT (''),
[UF5] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF5] DEFAULT (''),
[UF6] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF6] DEFAULT (''),
[UF7] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF7] DEFAULT (''),
[UF8] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF8] DEFAULT (''),
[UF9] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF9] DEFAULT (''),
[UF10] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UF10] DEFAULT (''),
[UFHeading1] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading1] DEFAULT (''),
[UFHeading2] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading2] DEFAULT (''),
[UFHeading3] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading3] DEFAULT (''),
[UFHeading4] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading4] DEFAULT (''),
[UFHeading5] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading5] DEFAULT (''),
[UFHeading6] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading6] DEFAULT (''),
[UFHeading7] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading7] DEFAULT (''),
[UFHeading8] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading8] DEFAULT (''),
[UFHeading9] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading9] DEFAULT (''),
[UFHeading10] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_UFHeading10] DEFAULT (''),
[DateAdded] [datetime] NULL,
[ReportType] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_ReportType] DEFAULT (''),
[CrystalParams] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StoreReportYN] [bit] NOT NULL CONSTRAINT [DF_Report_Desc_StoreReportYN] DEFAULT ((0)),
[StoreInterval] [int] NOT NULL CONSTRAINT [DF_Report_Desc_StoreInterval] DEFAULT ((0)),
[AccessKeywords] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Report_Desc_AccessKeywords] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Report_Desc] ADD CONSTRAINT [PK_Report_Desc] PRIMARY KEY CLUSTERED ([ImisSystem], [Category], [Title]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Report_Desc] TO [IMIS]
GRANT SELECT ON  [dbo].[Report_Desc] TO [IMIS]
GRANT INSERT ON  [dbo].[Report_Desc] TO [IMIS]
GRANT DELETE ON  [dbo].[Report_Desc] TO [IMIS]
GRANT UPDATE ON  [dbo].[Report_Desc] TO [IMIS]
GO